alter table qy_pddf add ny varchar(20)
alter table qy_xypjjl add czxbz [numeric](1, 0) DEFAULT 0 not NULL
alter table qy_pdfl_1 add czxbz [numeric](1, 0) DEFAULT 0 not NULL
alter table qy_pddf add czxbz [numeric](1, 0) DEFAULT 0 not NULL
alter table qy_xypjjl add reportyear [numeric](4, 0) DEFAULT 0 not NULL
alter table qy_xypjjl add result_5 varchar(8)

delete from qy_pdfl_2 where pdfl_2 in (select pdfl_2 from qy_pdxm where pdxm in (select pdxm
FROM qy_pdxmfs_js
WHERE (dyzd IN ('yyzs', 'rjxse', 'rjjlr', 'yjkfl'))))
GO

delete from qy_pdxm where pdxm in (select pdxm
FROM qy_pdxmfs_js
WHERE (dyzd IN ('yyzs', 'rjxse', 'rjjlr', 'yjkfl')))
GO

delete from qy_pdxmfs_js WHERE (dyzd IN ('yyzs', 'rjxse', 'rjjlr', 'yjkfl'))
GO

ALTER TABLE qy_cwzb_gy DROP COLUMN yyzs
GO
ALTER TABLE qy_cwzb_gy DROP COLUMN rjxse
GO
ALTER TABLE qy_cwzb_gy DROP COLUMN rjjlr
GO
ALTER TABLE qy_cwzb_gy DROP COLUMN yjkfl
GO